ToNumber before SubRecSetup was causing a crash because we were passing a fieldkey to FMNumtoFloat and the FileFormatPtr was invalid. Removed the ToNumber call before SubRecSetup, and all iC
s OK.
Valid
Mike Buckalew
Tony Zepeda
Tony Zepeda
Franz
7.0 Mac
7.1 Mac
1. launch Franz mac or pc.
2. define 2 number fields "number1" and "number2" then define a calculation calc = npv (number1, number2).
3. get out of Define Fields.
4. reOpen Define Fields, double click on thB
e calc field to open the Calculation dialog.
5. click Ok in the Calculation dialog and Done in Define Fields.
result : franz freezes on the mac. franz pc will die if you try to enter data in the number fieldC4s. stack crawl : evalPolish then it dies in doNPV.
REPORT NAME
alisA
Fali@
HBAM3016AUG95@
bcp132
dp104
gtp139
ocp102
13H Last WeekI
10/15/95...10/21/95
I'll Perform the Find
Pro 3.0F!
Pro 3.0M%
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
12/5/95
DESCRIPTION
INVOICE ID
LINE ITEM TOTAL
PRICE
PRODUCT ID
QUANTITY
Report Menu
Find Dialog
Summarize by Month
Summarize by Day
Summarize by Week
Summarize by Year
View as List
Report MenuB
REPORT NAME
SEARCH PERIOD
SEARCH PERIOD REPORT
TOTAL LINE ITEM
TOTAL QUANTITY
TOTAL RECORDS
Invoice IDB
Product IDB
DescriptionB
QuantityB
PriceB
Line Item TotalB
Total RecordsB
Search PeriodB
Search Period ReportB
Total Line ItemB
Total QuantityB
Report NameB
I'll Perform the FindL
Invoice 20
Find DialogB
Reports
Main
Reports
Reports
Main
Reports
Summarize
by DayW
Summarize
by WeekX
Summarize
by MonthY4Creating reports is quite easy and requires 3 steps:Z
3. Select the report below.[
Find Your Own\3There is currently <<
ABAH>> selected Line Item(s).]B1. Find the Invoices that you would like to create a report with.^
Your Own Reporta:Select the correct search request or Find Your Own Recordsb
Summarize
by Yearc
2. Name your report.
Summarize by MonthB
Main
Entry
View as
Reports
Invoice
Find a Line Item
Product ID
Price
Description
Quantity
Cancel
Invoice
Invoice Date
Summarize by DayB
Product IDF
DescriptionH
QuantityW
Summary Report by Month[
Search Range: <<
ABAJ>>h
Total Line Itemi
Printed //j
Printed by <<
AFAAABAEABAB>>k
Page ##u
AFAAABADABAB>> totals:v
Grand Totalw <<
ABAM>>
Summarize by WeekB
Product IDF
DescriptionH
QuantityW
Summary Report by Day[
Search Range: <<
ABAJ>>h
Total Line Itemi
Printed //j
Printed by <<
AFAAABAEABAB>>k
Page ##u
AFAAABADABAB>> totals:v
Grand Totalw <<
ABAM>>
Summarize by YearB
Product IDF
DescriptionH
QuantityW
Summary Report by Week[
Search Range: <<
ABAJ>>h
Total Line Itemi
Printed //j
Printed by <<
AFAAABAEABAB>>k
Page ##u!Week of <<
AFAAABADABAB>> totals:v
Grand Totalw <<
ABAM>>
View as ListB
Product IDF
DescriptionH
QuantityW
Summary Report by Year[
Search Range: <<
ABAJ>>h
Total Line Itemi
Printed //j
Printed by <<
AFAAABAEABAB>>k
Page ##u
AFAAABADABAB>> totals:v
Grand Totalw <<
ABAM>>
DP104C
Deer PosterD
12.00F
OCP102C
Oregon Coast PosterD
12.50F
BCP132C
Brookings Coast PosterD
GTP139C
Ghost Town PosterD
33.00F
GTP139C
Ghost Town PosterD
33.00F
OCP102C
Oregon Coast PosterD
12.50F
Your Own Script
Go to Main Menu
Go to Reports Menu
Go to Invoices
Preview or Print
Perform Find
Summarize by Day
Summarize by Week
Summarize by Month
Summarize by Year
Find from Report
Go to Main Menu
This database file is used by the Invoices file to store products purchased for an invoice. To enter a line item for an invoice, open the Invoices database and type the product ID.V
Line Items
Main
X:Line Items - line items are entered from Invoices database
Return
to Invoices
Invoice ID\
Product ID]
Description^
Quantity_
Price`
Line Item Total
Helvetica
Geneva
Times
Go to Reports Menu
Perform Find
"I'll Perform the Find"
I'll Perform the Find
Summarize by Day
Preview or Print
"Preview")
PreviewGB9
"Print")
PrintG
Summarize by Week
Summarize by Month
= "Last Week"
b)-1)-7) & "..." &
b+ (7 -
b)-7))
= "This Week"
b)-1)) & "..." &
b+ (7 -
= "Last Month"
b))) & "..." &
b)) -1)
= "This Month"
b))) & "..." &
b) + 1
b)) -1)
= "Last Year"
"1/1/" & (
)) -1) & "..." &
"12/31/" & (
))-1)
= "This Year"
"1/1/" &
)) & "..." &
"12/31/" &
= "I'll Perform the Find"
Last Week
This Week
Last Month
This Month
Last Year
1/1/
12/31/
This Year
1/1/
12/31/
I'll Perform the Find
) = 0
Cancel
:;<=>?@ABCDE
"#+./345>ABCGIL
&*268:H
There are no records that match your reports find request.H
Cancel
ADDFIELDSHRINKAGE
Please Select a find request.
Summarize by Year
Find from Report
"I'll Perform the Find"
I'll Perform the FindB
Your Own Script
Create your own script andB
attatch it to a button
Go to Invoices
wwwwww
ffffff
UUUUUU
DDDDDD
333333
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
UTdUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
wwxwwxw
JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))
'!!!!
*00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
QRPTH
FPTHAQDaffy:Desktop Folder:Franz Project:FM Pro Solution:2-Enabled Layouts:Products.FP3
MSPCA
NAMEA
Products.FP3
RPTHA
Products.FP3
ORPTH
FPTHAOAPS Drive
:Projects:Franz Project:FM Pro Solution:13-More Changes:Main Menu.FP3
APS Drive
Main Menu.FP3
FMP3FMP3
13-More Changes
OAPS Drive
:Projects:Franz Project:FM Pro Solution:13-More Changes:Main Menu.FP3
MSPCA
NAMEA
Main Menu.FP3
RPTHA
Main Menu.FP3
@@BA@
wwwwww
ffffff
UUUUUU
DDDDDD
333333
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
ffffff
UUUUUU
DDDDDD
333333
#4EWp
"4EVx
#3EVg
"4DUg
#3EVg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
" 234DUfw
2""2334DEVgx
3 4DEUfwx
3 DDUVgw
D EUUfwx
UDDEUUfgw
U Vfgwx
eUVfgww
(*)(%,3&
)%+@6)
",30,)%
#*>A6332+$"!
25,878
#&$690*"
!)0,++)(
"%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*
!$&(265389,#!$$
'275?
" $$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
%)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
$$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
!$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
#'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+,)+"
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!PQ
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGCA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
%'0>GFA:378+&&%$$,&
,:CPQ
$(,027CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
#%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
876=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,
169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,*3*)-/0/+&$$!
6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7)
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
&46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
#'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,
M4%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
B220
DDDDDD
B"#B0
B"#B"$
"2#B"#B"#@
2$""#B"#@
"2#B"#@
2$B"#@
DDDDDD
DDDDDD
wwwwww
ffffff
333333
""""""
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
333333
wwwwww
UUUUUU
DDDDDD
""""""
ORPTH
FPTHAOAPS Drive
:Projects:Franz Project:FM Pro Solution:15-More Changes:Main Menu.FP3
APS Drive
Main Menu.FP3
FMP3FMP3
15-More Changes
OAPS Drive
:Projects:Franz Project:FM Pro Solution:15-More Changes:Main Menu.FP3
MSPCA
NAMEA
Main Menu.FP3
RPTHA
Main Menu.FP3
APS Drive
Main Menu.FP3
FMP3FMP3
15-More Changes
OAPS Drive
:Projects:Franz Project:FM Pro Solution:15-More Changes:Main Menu.FP3
NRPTH
FPTHANAPS Drive
:Projects:Franz Project:FM Pro Solution:15-More Changes:Invoices.FP3
APS Drive
Main Menu.FP3
FMP3FMP3
13-More Changes
OAPS Drive
:Projects:Franz Project:FM Pro Solution:13-More Changes:Main Menu.FP3
NAMEA
Invoices.FP3
ZONEA
(LIST
LISTAYLast Week
This Week
Last Month
This Month
Last Year
This Year
I'll Perform the Find
VDEFA(
Search Values
FMRLA
FMRLA
FMRLA
FMRLA
ProductsB
GlobalsC
InvoicesD Main Menu
APS Drive
Invoices.FP3
FMP3FMP3
15-More Changes
NAPS Drive
:Projects:Franz Project:FM Pro Solution:15-More Changes:Invoices.FP3
MSPCA
NAMEA
Invoices.FP3
RPTHA
Invoices.FP3
APS Drive
Invoices.FP3
FMP3FMP3
15-More Changes
NAPS Drive
:Projects:Franz Project:FM Pro Solution:15-More Changes:Invoices.FP3
(.txt)